Dates = 
 ADDCOLUMNS (
 CALENDARAUTO(),
   "MonthNr", MONTH( [Date] ), 
   "MonthName", FORMAT( [Date], "MMMM", "en-us" ),
   "Year", YEAR( [Date] ), 
   "Week", WEEKNUM( [Date],21 ),
   "DayOfWeekNr", WEEKDAY ( [Date] , 2),
   "DayOfWeekName", FORMAT ( [Date], "dddd" ),
   "Quarter", "Q" & FORMAT( [Date], "Q" ),
   "YearQuarter", FORMAT( [Date], "YYYY" ) & "-Q" & FORMAT ( [Date], "Q" ) ,
   "YearAndMonth", YEAR( [Date] ) & "-" & FORMAT( [Date], "MM" )

)
